alter table jms_dm.dm_sqs_tab_take_arr_network_dt
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_sqs_tab_take_arr_network_dt;
create external table jms_dm.dm_sqs_tab_take_arr_network_dt
(
    network_code string comment '网点编码',
    network_name string comment '网点名称',
    taking_cnt   int comment '收件量',
    arrival_cnt  int comment '到件量',
    date_time    string comment '日期'
)
    COMMENT '客诉操作量收发'
    PARTITIONED BY ( dt STRING COMMENT 't-1')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_sqs_tab_take_arr_network_dt'
;